One moment please...
 
 
Exact Financials   
 

GL_TRANS

GL_TRANS (acc_nr,co,curr_code,FY,period,calc)

By using this function, you can retrieve the balance of all transactions of a general ledger account.

Example

GL_TRANS (0500,100,EUR,2005,1,1)

The balances of all transactions on general ledger account 0500 in company 100, in currency 'EUR', in period 1 in 2005 are included in the worksheet.

Parameters

Description Explanation Value
Calc Only values of the current period are shown. 1
The cumulative amount up to and including the current period is shown. 2

See also:

[Alphabetical overview of parameters]


Excel Add-in Manual > Contents > Functions > GL_TRANS


     
 Main Category: Support Product Know How  Document Type: Support - On-line help
 Category: On-line help files  Security  level: All - 0
 Sub category: Details  Document ID: 18.314.685
 Assortment:  Date: 01-12-2008
 Release:  Attachment:
 Disclaimer